Assistance with a formula to display 18/16

[pedro-egoli]

Some assistance please.
In cell E6 is the number 1927 , and in cell e3 the number is 107.
In cell e16 the number is 16.86

What I want is a formula that will show in cell e35 the following

18/16.86

The formula I have tried is

=IF(ISBLANK(E3),"",text(E6/E3,"0.0")&" /"&text(e16),"0.0"))

However, I get the message "entered too few arguments"

Can someone tweak this formula using cell numbers please

Pedro

 

[JamesW]

Hi,

You have 1 too many ) -TEXT(E16),"0.0" should be TEXT(E16,"0.0"):

=IF(ISBLANK(E3),"",TEXT(E6/E3,"0.0")&" /"&TEXT(E16,"0.0"))

Not tested the above with data though, so it only fixes the "too few arguments" error. Let me know if it's what you want to see first, then we will work from there if it isn't..

 

[pedro-egoli]

Thanks James , works perfectly

Pedro