LinkBack URL
About LinkBacks
Can anyone help me with this? I need C45 to change values when G51 has a certain value: Here is and example of the formula =if(G51=200,"50") but if G51 = 400 I need C45 to equal 100 and if G51 = 600 I need C45 to equal 150.
Can anyone help me with this? I need C45 to change values when G51 has a certain value: Here is and example of the formula =if(G51=200,"50") but if G51 = 400 I need C45 to equal 100 and if G51 = 600 I need C45 to equal 150.
Try this formula in C45
=G51/4
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Here is a possibility that only accepts the values given for G51 and only returns the values specified if those values are in G51. If something other than the specified values is entered in G51 a blank cell is the result:
Formula:
Please Login or Register to view this content.
Another one:
Formula:Please Login or Register to view this content.
And another one:
Formula:Please Login or Register to view this content.
Last edited by newdoverman; 07-16-2015 at 04:10 PM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks