Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

If Or statement 1

Status
Not open for further replies.

gizmo1973

MIS
Joined
Aug 4, 2004
Messages
2,828
Location
GB
I'm having a brain freeze here and can't remember how to do this, help and searching on here provides no help (key words probably too small)... here goes.

I need a formula that goes like this

=IF($E$1>G82,"Feedback Required"," ")I have this bit already
but also if G82 is blank/null I want " " as well
I think this should be an if/or but can't express it, help!!!!!

Regards, Phil.

M.U.F.C. Show your true support here, it's still not too late:
"Shares not Shirts
 
Giz - turn it on its head:

=IF(OR($E$1<G82,G82="")," ","Feedback Required")

Rgds, Geoff

"Errors have been made....Others will be blamed"

Please read FAQ222-2244 before you ask a question
 
no worries Gizmo

Rgds, Geoff

"Errors have been made....Others will be blamed"

Please read FAQ222-2244 before you ask a question
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top