how do i create this if formula?

[zilch4ry]

hi all,

i have an really slight problem- im creating a spreadsheet which identifies how many tills are needed open per hour- what ive been trying to do for the last 30 minutes is create an if formula based on if the number is "1" the text will be displayed "till needed per HR" and if the value is anything higher than 1 the text will read "tills needed per HR".

Its such a basic thing that i thought it would only take a second, can anybody tell me why this isnt working:

=IF(COUNTIF(G4,1),"till needed per hr.","tills needed per hr.")

If anybody knows the formula which can be used it would be much appreciated

cheers,

tom

 

[jeffreybrown]

Hi Tom,

I would think this would do...

=IF(G4=1,"till needed per hr.","tills needed per hr.")

 

[Ron Coderre]

Maybe this...

=" till"&IF(A1=1,"","s")&" needed per hour"

Is that something you can work with?

 

[T. Valko]

hi all,

i have an really slight problem- im creating a spreadsheet which identifies how many tills are needed open per hour- what ive been trying to do for the last 30 minutes is create an if formula based on if the number is "1" the text will be displayed "till needed per HR" and if the value is anything higher than 1 the text will read "tills needed per HR".

Its such a basic thing that i thought it would only take a second, can anybody tell me why this isnt working:

=IF(COUNTIF(G4,1),"till needed per hr.","tills needed per hr.")

If anybody knows the formula which can be used it would be much appreciated

cheers,

tom

Try this...

=IF(COUNT(G4),"Till"&IF(G4=1,"","s")&" needed per hour","")

 

[zilch4ry]

it turns out the vlookup im using although it says "1" the value 1 isn't there apparently.

 

[Dryver14]

Try this for nothing

=IF(G4+0<1,"",IF(G4+0=1,"Till needed per hr","Tills needed per hr"))

 

[zilch4ry]

i havent got a clue whats wrong with it, its not showing up as nothing - 1, 2, 3 , 10 - nothing

 

[Dryver14]

what are you saying? is the Vlookup not returning anything or is the number there and the formulas not working if so try my IF with the plus 0 which should return a number instead of text

 

[zilch4ry]

No its the vlookup ive used- the answer is clearly "1" at the moment, but no formula ive tried (even a simple countif) is showing that the answer value is 1; something is really messed up with it