Error in the Excel formula

[senthile]

Hi All,

when i use the excel formula "=IF(H13<=200,12500,12500+ROUNDUP(IF(H13>200,IF((H13-200)>800,SUM(H13-200)),0)/50,0)*1750),IF(H13>1000,(ROUNDUP(SUM(H13-1000)/50,0))*1250)" getting an error as "#VALUE!". attached the formula in excel. help me to fix this.

Thanks and Regards,
Senthil

[Zeta84]

Example.jpg

It's because you are attempting to basically write this function

=If(),If()

in the same cell

The function will try to only produce 1 output, but its seems that you want 2.

If you want the result to be 12519,3750. I'd recommend having the two If's in different cells, and then CONCATENATE(Cell1,",",Cell2).

[ThirdFret]

I think I might understand what you're trying to do. Let me know if the following formula returns the desired result:

Please Login or Register  to view this content.

[senthile]

Hi Zeta84,

can you please correct and share me the formula for the below.
=IF(A1<=200,12500,12500+ROUNDUP(IF(A1>200,IF((A1-200)>800,SUM(A1-200)),0)/50,0)*1750),IF(A1>1000,(ROUNDUP(SUM(A1-1000)/50,0))*1250)

Best Regards,
Senthil

[senthile]

hi..
Can you pls update on the below mail?
Thanks.. Senthil

[ThirdFret]

I think the answer Zeta84 provided for the original question applies to this version of the formula.

I don't think it's clear what output you're looking for. What outputs are you expecting? Please provide an example file that shows the desired result as a hard-coded value.

Does the following formula produce the result you're expecting?

Please Login or Register  to view this content.