Newbie Question :-D

[dafricano]

Hello everyone,

I have an excel form that calculates a budget. What I am trying to do is if the final tally is postive, row 106 would appear with the tally and a message stating 'This amount is due to the CUstomer'

If it's negative, row 107 would appear with the tally and a message stating 'This amount is due to the company'

The tally cell is E105

Please let me know if I need to explain something else..
Thanks

Dave

 

[macleanb]

It would be easier to use a single cells which does either:

=if(e105>0,"You get ",if(e105<0,"We get ","")) & e105

 

[Aladin Akyurek]

Since you seem to have the tally (or the amount) already in E105...

E106:

=IF(E105>=0,"This amount is due to the Customer: "&E105,"")

E107:

=IF(E105 < 0,"This amount is due to the Company: "&E105,"")

 

[dafricano]

Thanks for the repsonses gentlemen,

How can I specify the number in the output to have a currency formatting

So..
Instead of
Due to My Company. -100

Due to My Company. .......

Actually i just figured this out...

=IF(E105>0,"Due to Home Owner " & "$" & E105 & ".00",IF(E105<0,"Due to My Company. " & "$" & -E105 & ".00",""))

THanks for all your help guys!!

Dave

 

[Seti]

Try:

=IF(E105>0,"Due to Home Owner " & TEXT(E105,"$#,##0.00"),IF(E105<0,"Due to My Company. " & TEXT(-E105,"$#,##0.00"),""))